Reviewing data fields and data types is an essential step in Tableau data preparation. Before creating charts, reports, and dashboards, users should understand what each field represents and how Tableau interprets its values. Correct field names, data types, and field roles help ensure accurate calculations, appropriate visualizations, and reliable business insights.
Learn more: JustAcademy Tableau Training | Register for a Tableau Course Demo
A data field represents a particular attribute or category of information in a dataset. When Tableau connects to a data source, columns from tables or files generally become fields that appear in the Data pane.
Each field contains information about a specific subject, such as customer names, product categories, order dates, sales amounts, or profit values.
| Order ID | Customer Name | Order Date | Region | Sales | Profit |
|---|---|---|---|---|---|
| 101 | Amit Sharma | 2026-01-05 | North | 50000 | 8000 |
| 102 | Neha Verma | 2026-01-10 | South | 30000 | 5000 |
| 103 | Rahul Singh | 2026-02-12 | West | 20000 | 3000 |
In this dataset, Order ID, Customer Name, Order Date, Region, Sales, and Profit are individual fields. Each field has a purpose and should be interpreted correctly before analysis.
A data type defines the kind of information stored in a field. It tells Tableau how to interpret the values and which operations are appropriate for them.
For example, a date field supports date-based analysis, a numeric field can be aggregated, and a text field can be used to categorize records.
| Data Type | Description | Example |
|---|---|---|
| String (Text) | Stores letters, words, symbols, and text-based identifiers. | Customer Name, Product |
| Number (Whole) | Stores integer values without decimal places. | Quantity, Employee Count |
| Number (Decimal) | Stores numeric values that can include decimal places. | Sales, Profit, Discount |
| Date | Stores calendar dates. | 2026-01-05 |
| Date & Time | Stores a date and a time. | 2026-01-05 14:30:00 |
| Boolean | Represents true or false values; availability depends on the data source. | Is Active: True |
| Geographic Role | Identifies geographic fields for mapping; this is a field role rather than a separate basic storage type. | Country, State, City |
Tableau also supports other specialized field roles and data types depending on the source and feature being used. Geographic roles, for example, help Tableau recognize location information for maps.
| Data Field | Data Type |
|---|---|
| Represents a specific attribute in the dataset. | Defines the kind of values stored in that field. |
| Examples include Sales, Customer Name, and Order Date. | Examples include Number, String, and Date. |
| Used to organize and analyze information. | Determines how Tableau interprets and processes the values. |
| Appears as a field in the Data pane. | Indicated by a data type icon associated with the field. |
Example: Sales is the field name, while Number (Decimal) is its data type. Order Date is the field name, while Date is its data type.
The Data pane is located on the left side of a Tableau worksheet. It displays available data sources and the fields that can be used to create visualizations.
Tableau organizes fields into dimensions and measures. This classification influences how fields are used in visualizations.
Dimensions are fields used to categorize, group, segment, or describe data. They commonly contain text, dates, geographic information, or identifiers.
Examples: Customer Name, Region, Product Category, Order Date, and Customer ID.
Dimensions help answer questions such as which region generated sales, which product category performed best, or how results differ by month.
Measures are fields containing quantitative values that can be measured or aggregated. Tableau commonly aggregates measures when they are added to a view.
Examples: Sales, Profit, Quantity, Cost, and Discount Amount.
Measures help answer questions such as total sales, average profit, or the number of products sold.
| Feature | Dimensions | Measures |
|---|---|---|
| Purpose | Categorize or describe data. | Measure or quantify data. |
| Typical examples | Region, Product, Customer | Sales, Profit, Quantity |
| Typical use | Grouping and segmentation. | Aggregation and comparison. |
| Default behavior | Often define the level of detail in the view. | Often use an aggregation such as SUM. |
Important: A field's data type and its role as a dimension or measure are different concepts. A numeric field can be used as a dimension, such as an order number or postal code, when the values identify categories rather than quantities.
Tableau also classifies fields as discrete or continuous. This classification influences how values appear in a visualization.
Discrete fields represent separate, distinct values. They commonly create headers or categories in a view and are generally shown in blue.
Examples: Region, Product Category, Customer Name, and discrete date parts such as Month.
Continuous fields represent values along a continuous range. They commonly create axes in a visualization and are generally shown in green.
Examples: Sales, Profit, and a continuous date range.
| Feature | Discrete | Continuous |
|---|---|---|
| Appearance in Tableau | Usually blue. | Usually green. |
| Typical display | Headers or distinct categories. | Continuous axes or ranges. |
| Example | Separate region names. | A numeric sales axis. |
| Common purpose | Compare distinct groups. | Show a range, scale, or trend. |
A field can be discrete or continuous independently of whether it is a dimension or measure, although some combinations are more common than others.
Tableau displays an icon beside a field name to indicate its data type. Recognizing these icons helps you identify how Tableau currently interprets each field.
| Field Example | Expected Type | What to Check |
|---|---|---|
| Customer Name | String | Names should be interpreted as text. |
| Sales | Number (Decimal) | Values should support numeric calculations. |
| Quantity | Number (Whole) | Counts should be whole numbers when appropriate. |
| Order Date | Date | Dates should support date filtering and grouping. |
| Order Timestamp | Date & Time | Both date and time information should be retained. |
| Country | String with a geographic role where appropriate | Verify that Tableau recognizes the location for mapping. |
Sometimes Tableau automatically assigns an incorrect data type to a field. You can change it on the Data Source page or in the Data pane when the source and field support the operation.
Example: If Order Date is recognized as a string, Tableau may not offer the same date-based grouping and filtering behavior. Changing it to Date, when the values can be interpreted correctly, allows Tableau to treat it as a date field.
Best practice: Verify data types before creating an extract. Tableau warns that incorrect type interpretation can affect data accuracy, including the precision of numeric values.
String fields contain text, labels, codes, and other character-based information. They are commonly used to categorize data or identify records.
Do not convert identifiers to numeric types simply because they contain digits. Postal codes, product codes, and customer IDs often need to remain text because arithmetic calculations on them are not meaningful.
Numeric fields contain values used for calculations, aggregation, comparisons, and numerical analysis.
Sales
5000
7500
2500If Sales is a numeric field, Tableau can calculate its total as 15,000. If the values are interpreted as text, the expected numerical aggregation may not work until the data is corrected.
Date fields are important for time-based analysis, trend reporting, and period comparisons.
Order Date
2026-01-05
2026-01-10
2026-02-12With a correctly interpreted date field, you can analyze sales by day, month, quarter, or year and create time-series visualizations.
Tableau can assign geographic roles to recognized location fields. These roles help Tableau interpret geographic information and use it in map visualizations.
Geographic roles do not guarantee that every location will be recognized. Ambiguous place names may need additional location information or correction.
A mixed-type column contains different kinds of values in the same field, such as numbers, text, dates, or blanks. Tableau generally assigns one data type to the field, so mixed values may not all be interpreted as intended.
Sales
5000
7500
Unknown
2500The value Unknown is text, while the other values are numbers. If Tableau interprets the field as numeric, the text entry may be treated as null.
Tableau's type detection for mixed-value Excel and CSV columns considers a limited initial sample of rows. Therefore, inspect fields carefully instead of assuming that every value in a column was interpreted correctly.
Clear field names make datasets easier to understand and reduce confusion when building reports and dashboards.
| Original Field | Improved Field Name |
|---|---|
| Cust_Nm | Customer Name |
| Ord_Dt | Order Date |
| Sales_Amt | Sales Amount |
| Qty | Quantity |
| Prof | Profit |
Data type describes the kind of information a field stores. Field roles and classifications describe how Tableau uses that information in analysis.
| Concept | Meaning | Example |
|---|---|---|
| Data Type | Kind of stored value. | Number, String, Date |
| Dimension or Measure | Whether a field is used to categorize or quantify data. | Region as a dimension; Sales as a measure |
| Discrete or Continuous | Whether a field is displayed as distinct categories or a continuous range. | Blue discrete Region; green continuous Sales |
| Geographic Role | Identifies geographic meaning for mapping. | City, State, Country |
Important: Changing a field's data type does not automatically mean that its dimension/measure classification or discrete/continuous behavior will match your analytical needs. Review these properties separately.
Objective: Inspect a sales dataset, identify data types, and correct any field issues before creating a visualization.
| Order ID | Customer Name | Order Date | Region | Quantity | Sales |
|---|---|---|---|---|---|
| 1001 | Amit Sharma | 2026-01-05 | North | 2 | 50000.50 |
| 1002 | Neha Verma | 2026-01-10 | South | 3 | 30000.00 |
| 1003 | Rahul Singh | 2026-02-12 | north | 1 | 20000.75 |
| 1004 | Priya Patel | 2026-02-15 | West | 4 | 15000.00 |
You should be able to identify data fields, recognize data types, distinguish dimensions from measures, and correct basic field interpretation issues before creating a visualization.
| Problem | Possible Cause | Solution |
|---|---|---|
| Sales cannot be aggregated correctly. | Values may be stored as text. | Inspect the values and change the type to numeric when appropriate. |
| Dates are displayed as text. | Tableau detected the wrong type or the date format is inconsistent. | Correct the format and change the field to Date or Date & Time. |
| Some values become null. | Values do not match the assigned data type. | Inspect the source and correct or separate invalid values. |
| Customer IDs lose leading zeros. | An identifier was converted to a numeric type. | Use a text type when leading zeros are meaningful. |
| One region appears multiple times. | Different spelling, capitalization, or spacing. | Verify and standardize category values. |
| A map cannot identify locations. | The geographic role is missing or the location is ambiguous. | Assign the appropriate geographic role and verify location values. |
| Decimal precision is lost. | A decimal field may have been interpreted as an integer before extract creation. | Verify the source type and correct the data type before creating or refreshing an extract as appropriate. |
A data field represents an attribute or column of information, such as Customer Name, Sales, Region, or Order Date.
A data type defines the kind of values stored in a field and how Tableau interprets those values.
Common types include String, Number (Whole), Number (Decimal), Date, and Date & Time. Other supported types and roles depend on the data source and features used.
A dimension is generally used to categorize or describe data, while a measure is used to quantify data and can commonly be aggregated.
Discrete fields represent distinct values and generally appear in blue, while continuous fields represent ranges and generally appear in green.
Yes. A numeric identifier, such as an order number or postal code, may be used as a dimension because it identifies a category rather than a quantity to aggregate.
Click the field's data type icon on the Data Source page or in the Data pane, then choose an appropriate supported type.
A mixed-type column contains values of different types, such as numbers and text, which can cause incorrect interpretation or null values.
Incorrect type interpretation can affect data accuracy. For example, interpreting decimal values as integers may cause loss of precision.
A geographic role identifies the geographic meaning of a field so Tableau can use it in mapping, when the locations are recognized.
Reviewing data fields and data types is a fundamental Tableau skill. Correctly identifying fields, verifying their data types, understanding dimensions and measures, and checking discrete or continuous behavior help you prepare data for meaningful analysis. By validating fields before creating charts and dashboards, you can reduce errors and produce more reliable business insights.
Continue learning with JustAcademy Tableau Training or Register for a Tableau Course Demo.
